@echo off
chcp 65001
set locatPath=%~dp0

echo "备份报告"
set hour=%time:~0,2%
if %hour% leq 9 (
	set path=%date:~3,4%%date:~8,2%%date:~11,2%_0%time:~1,1%%time:~3,2%%time:~6,2%
) else (
	set path=%date:~3,4%%date:~8,2%%date:~11,2%_%time:~0,2%%time:~3,2%%time:~6,2%
)
echo %path%
echo %locatPath%
mkdir %locatPath%report\backups\%path%
move %locatPath%report\html %locatPath%\report\backups\%path%

echo "还原数据库"
echo "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -uroot -proot goods <sqlTest_back.sql